package com.cxp.repository;

import com.cxp.entity.Projects;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * Created by cunxp on 2018/5/24.
 */
@Repository
public interface ProjectRepository extends PagingAndSortingRepository<Projects, String>, JpaSpecificationExecutor<Projects> {

    @Query(value = "select * from projects  where id = ?1",nativeQuery = true)
    Projects queryById(String id);
}
